UCSF

Parameters Provided:

name.synonym = (6R,7S)-3-[[(aminocarbonyl)oxy]methyl]-7alpha-[[(R)-5-amino-5-carboxy-1-oxopentyl]amino]-7-methoxy-8-oxo-5-thia-1-azabicyclo[4.2.0]oct-2-ene-2-carboxylic acid; A 16886B; A-16886B; A16886B; Cephamycin C; antibiotic 842A; antibiotic A-16886B; antibiotic A-1
filter.purchasability = all
page.num = 1

Structural Results Found: (before additional filtering)

SQL Query Was

SELECT DISTINCT(ci.sub_id_fk) AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id INNER JOIN synonym AS syn ON (ci.cat_id_fk=syn.cat_fk AND ci.supplier_code=syn.supplier_code) INNER JOIN field AS f ON syn.field_fk=f.field_id  WHERE c.free = 1 AND syn.synonym IS NOT NULL AND syn.synonym LIKE '(6R,7S)-3-[[(aminocarbonyl)oxy]methyl]-7alpha-[[(R)-5-amino-5-carboxy-1-oxopentyl]amino]-7-methoxy-8-oxo-5-thia-1-azabicyclo[4.2.0]oct-2-ene-2-carboxylic acid; A 16886B; A-16886B; A16886B; Cephamycin C; antibiotic 842A; antibiotic A-16886B; antibiotic A-1' AND f.ftype IN (3,7,11,12,14) AND ci.sub_id_fk IN (SELECT ci.sub_id_fk AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id  WHERE c.free = 1   )    LIMIT 50

Permalink

//zinc12.docking.org/results/combination?name.synonym=%286R%2C7S%29-3-%5B%5B%28aminocarbonyl%29oxy%5Dmethyl%5D-7alpha-%5B%5B%28R%29-5-amino-5-carboxy-1-oxopentyl%5Damino%5D-7-methoxy-8-oxo-5-thia-1-azabicyclo%5B4.2.0%5Doct-2-ene-2-carboxylic+acid%3B+A+16886B%3B+A-16886B%3B+A16886B%3B+Cephamycin+C%3B+antibiotic+842A%3B+antibiotic+A-16886B%3B+antibiotic+A-1&filter.purchasability=all

Embed Link to Results